package com.lxl.xm.mapper;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.lxl.xm.model.entity.Advertiser;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import scala.Int;

/**
* @author 86135
* @description 针对表【advertiser(广告商家表)】的数据库操作Mapper
* @createDate 2024-02-06 15:39:32
* @Entity com.lxl.model.entity.Advertiser
*/
@Mapper
public interface AdvertiserMapper extends BaseMapper<Advertiser> {
    Page<Advertiser> selectAdvertiserPage(Page<?>page);

    /**
     * 注册，插入数据
     * @param advertiser
     */
    void registerAdvertiser(Advertiser advertiser);

    /**
     * 根据邮箱查询
     * @param email
     * @return
     */
    Advertiser queryByEmail(String email);

    @Select("SELECT count(id) FROM `advertiser`")
    Integer getcount();
}




